How to: Link an existing file to a worksheet.
Solution:
Select the cell where the upper-left corner of the source file should appear. Select 'Object...' from the 'Insert' menu. Click the 'Create From File' tab from the 'Object' dialog box. Type the filename of the source file, select the 'Link to File' check box, and choose 'OK'.
1) Select the cell where the upper-left corner of the source file should appear.
2) Select the 'Insert' menu and select 'Object...'. (The Object dialog box appears.)
3) Click 'Create from File' tab.
4) Do one of the following:
a) Type the filename along with its path in the 'File Name' box.
b) Locate the path and the filename with the 'Browse...':
1] Click 'Browse...'. (The Browse dialog box appears.)
2] Select the drive where the source file is located in the 'Look in' dialog box. (All folders within the selected drive appear.)
3] Select the folder that contains the file. (The folder opens with its files and subfolders.)
4] If the file is located in a subfolder, select the subfolder.
NOTE: If necessary, repeat Step 4)b)4] until the source file is displayed.
5] Select the source file. (The file is highlighted.)
6] Click 'Insert'. (The path and the filename appear in the File Name box.)
5) Select the 'Link to File' check box.
the Link to File check box
6) Click 'OK'.
